MaxNum Aggregate Functoid
Description: The MaxNum Aggregate Functoid will return the largest numeric value within the records provided to the input Field for the entire table or in case that a group functoid has been used the largest numberic value of the records within each group.
Inputs with their allowed values:
- Field
- Output of another Functoid (Iterated)
- Value of a Table
Picture of the MaxNum Aggregate Functoid
Remark: Any non-numeric values passing through wil cause an empty return value.
Example: Example 1: Table with group by
Group By |
Values |
Result of MaxNum |
Group1 |
2 |
4 |
Group1 |
4 |
4 |
Group2 |
3 |
7 |
Group2 |
7 |
7 |
See Figure 1.
Figure 1